﻿CREATE TABLE [dbo].[Patient]
(
	[Id] INT NOT NULL PRIMARY KEY IDENTITY, 
    [Name] NVARCHAR(50) NOT NULL, 
    [MedicalRecordNumber] INT NOT NULL, 
    [Gender] NVARCHAR(10) NOT NULL, 
    [DateOfBirth] DATE NULL, 
    [PhoneNumber] NVARCHAR(30) NULL, 
    [EmailAddress] NVARCHAR(30) NULL, 
    [HomeAddressLine1] NVARCHAR(100) NULL, 
    [HomeAddressLine2] NVARCHAR(100) NULL, 
    [HomeAddressCity] NVARCHAR(30) NULL, 
    [HomeAddressState] NVARCHAR(30) NULL, 
    [HomeAddressPostalCode] NVARCHAR(10) NULL, 
    CONSTRAINT [AK_Patient_MedicalRecordNumber] UNIQUE ([MedicalRecordNumber])
)
